Returns the Weibull distribution. Use this distribution in reliability analysis, such as calculating a device's mean time to failure.
Syntax
WEIBULL(x,alpha,beta,cumulative)
X is the value at which to evaluate the function.
Alpha is a parameter to the distribution.
Beta is a parameter to the distribution.
Cumulative determines the form of the function.
Remarks
Example
The example may be easier to understand if you copy it to a blank spreadsheet.
Selecting an example from Help
Data | Description |
---|---|
105 | Value at which to evaluate the function |
20 | Alpha parameter to the distribution |
100 | Beta parameter to the distribution |
Formula | Description (Result) |
=WEIBULL(A2,A3,A4,TRUE) | Weibull cumulative distribution function for the terms above (0.929581) |
=WEIBULL(A2,A3,A4,FALSE) | Weibull probability density function for the terms above (0.035589) |